import pandas as pd

# s1 = pd.Series(data=[1,2,3],index=[1,2,3],name='A')
# s2 = pd.Series(data=[4,5,6],index=[1,2,3],name='B')
# s3 = pd.Series(data=[7,8,9],index=[1,2,3],name='C')


s1 = pd.Series(data=[1,2,3],name='A')
s2 = pd.Series(data=[4,5,6],name='B')
s3 = pd.Series(data=[7,8,9],name='C')


# s1 = pd.Series(data=[1,2,3],index=['天','地','玄'],name='A')
# s2 = pd.Series(data=[4,5,6],index=['天','地','玄'],name='B')
# s3 = pd.Series(data=[7,8,9],index=['天','地','玄'],name='C')



df = pd.DataFrame({s1.name:s1,s2.name:s2,s3.name:s3})

df=df.set_index('A')


print(df)







df.to_excel(rf'D:\Desktop\mynewlearn\pandas6.xlsx')

